/*
 Navicat MySQL Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost
 Source Database       : springboot-web

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : utf-8

 Date: 02/23/2020 21:45:08 PM
*/

SET NAMES utf8;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
--  Table structure for `employee`
-- ----------------------------
DROP TABLE IF EXISTS `employee`;
CREATE TABLE `employee` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(25) NOT NULL,
  `sex` char(1) NOT NULL,
  `age` int(11) NOT NULL,
  `birthday` date NOT NULL,
  `role` varchar(20) NOT NULL,
  `create_time` datetime NOT NULL,
  `update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1231481551225155587 DEFAULT CHARSET=utf8;

-- ----------------------------
--  Records of `employee`
-- ----------------------------
BEGIN;
INSERT INTO `employee` VALUES ('1231419762785456129', '张三', '1', '25', '2015-05-20', '普通员工', '2020-02-22 00:00:00', null), ('1231419839184703490', '张聊', '1', '25', '2015-05-20', '普通员工', '2020-02-22 00:00:00', '2020-02-23 01:23:44'), ('1231420088246669314', '张三溜', '1', '25', '2015-05-20', '普通员工', '2020-02-22 00:00:00', '2020-02-23 01:23:29'), ('1231465129673576450', '李四红', '2', '18', '2015-05-20', '普通员工', '2020-02-23 00:25:41', '2020-02-23 01:23:10'), ('1231473390355316737', '王五', '2', '20', '2015-05-20', '普通员工', '2020-02-23 00:58:31', '2020-02-23 00:58:31'), ('1231473908112723969', '张红', '1', '22', '2015-05-22', '普通员工', '2020-02-23 01:00:34', '2020-02-23 01:22:45'), ('1231481551225155586', '王一一', '2', '21', '2015-03-28', '普通员工', '2020-02-23 01:30:56', '2020-02-23 02:31:31');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
